## [1] "After population data extraction, 3 countries in master_data were not found in countries_population (and will be dropped):"
## [1] "Diamond Princess" "MS Zaandam" "Summer Olympics 2020"
Country Rankings
Increases
Top 20 Countries - Increase Deaths Avg Avg
|
Country_Region
|
Increase_Deaths_Avg_Avg
|
|
Indonesia
|
1345
|
|
Brazil
|
824
|
|
United States
|
814
|
|
Russia
|
787
|
|
Mexico
|
611
|
|
Iran
|
571
|
|
India
|
473
|
|
South Africa
|
354
|
|
Vietnam
|
332
|
|
Malaysia
|
259
|
|
Thailand
|
218
|
|
Bangladesh
|
190
|
|
Burma
|
190
|
|
Philippines
|
187
|
|
Argentina
|
184
|
|
Turkey
|
163
|
|
Sri Lanka
|
161
|
|
Kazakhstan
|
150
|
|
Tunisia
|
127
|
|
Colombia
|
124
|
Top 20 Countries - Increase Weighted Deaths Avg per 1e+06 people
|
Country_Region
|
Increase_Weighted_Deaths_Avg_Avg
|
|
Georgia
|
12.17
|
|
Fiji
|
11.59
|
|
Tunisia
|
10.83
|
|
Botswana
|
10.38
|
|
Eswatini
|
8.27
|
|
Kazakhstan
|
7.92
|
|
Malaysia
|
7.91
|
|
Sri Lanka
|
7.34
|
|
Cuba
|
7.18
|
|
Iran
|
6.74
|
|
South Africa
|
5.93
|
|
Russia
|
5.38
|
|
North Macedonia
|
5.11
|
|
Trinidad and Tobago
|
5.02
|
|
Indonesia
|
4.96
|
|
Mexico
|
4.85
|
|
Suriname
|
4.71
|
|
Namibia
|
4.24
|
|
Jamaica
|
4.20
|
|
Seychelles
|
4.12
|
Top 20 Countries - Increase Confirmed Avg Avg
|
Country_Region
|
Increase_Confirmed_Avg_Avg
|
|
United States
|
139191
|
|
Iran
|
38051
|
|
India
|
34927
|
|
United Kingdom
|
29991
|
|
Brazil
|
29391
|
|
France
|
24206
|
|
Indonesia
|
23281
|
|
Thailand
|
21407
|
|
Turkey
|
21297
|
|
Malaysia
|
20923
|
|
Russia
|
20863
|
|
Japan
|
19235
|
|
Mexico
|
18189
|
|
Philippines
|
12873
|
|
Spain
|
12369
|
|
South Africa
|
11452
|
|
Vietnam
|
9062
|
|
Cuba
|
8858
|
|
Morocco
|
8591
|
|
Iraq
|
8369
|
Top 20 Countries - Increase Weighted Confirmed Avg per 1e+04 people
|
Country_Region
|
Increase_Weighted_Confirmed_Avg_Avg
|
|
Georgia
|
13.17
|
|
Dominica
|
10.44
|
|
Cuba
|
7.92
|
|
Kosovo
|
7.42
|
|
Israel
|
6.86
|
|
Montenegro
|
6.85
|
|
Botswana
|
6.61
|
|
Malaysia
|
6.40
|
|
Seychelles
|
5.70
|
|
Eswatini
|
5.47
|
|
Fiji
|
5.34
|
|
Saint Lucia
|
5.01
|
|
Iran
|
4.49
|
|
United Kingdom
|
4.47
|
|
Cyprus
|
4.27
|
|
Kazakhstan
|
4.19
|
|
United States
|
4.19
|
|
Mongolia
|
4.03
|
|
North Macedonia
|
3.65
|
|
France
|
3.59
|
Totals
Top 20 Countries - Total Deaths
|
Country_Region
|
Deaths
|
|
United States
|
628303
|
|
Brazil
|
574209
|
|
India
|
434367
|
|
Mexico
|
252927
|
|
Peru
|
197752
|
|
Russia
|
172257
|
|
United Kingdom
|
131909
|
|
Italy
|
128728
|
|
Indonesia
|
125342
|
|
Colombia
|
124121
|
|
France
|
113472
|
|
Argentina
|
110217
|
|
Iran
|
101354
|
|
Germany
|
91983
|
|
Spain
|
83136
|
|
South Africa
|
79251
|
|
Poland
|
75316
|
|
Ukraine
|
56457
|
|
Turkey
|
54327
|
|
Chile
|
36605
|
Top 20 Countries - Total Weighted Deaths per 1e+06 people
|
Country_Region
|
Weighted_Deaths
|
|
Peru
|
5986
|
|
Hungary
|
3088
|
|
Bosnia and Herzegovina
|
2927
|
|
Czech Republic
|
2841
|
|
North Macedonia
|
2733
|
|
Brazil
|
2689
|
|
Montenegro
|
2681
|
|
San Marino
|
2679
|
|
Bulgaria
|
2670
|
|
Moldova
|
2447
|
|
Colombia
|
2431
|
|
Argentina
|
2406
|
|
Slovakia
|
2298
|
|
Belgium
|
2189
|
|
Italy
|
2177
|
|
Paraguay
|
2115
|
|
Slovenia
|
2104
|
|
Croatia
|
2056
|
|
Mexico
|
2007
|
|
Poland
|
1973
|
Maps
Plots
# CountryList <- bind_rows(top_Increase_Weighted_Deaths_Avg_Avg %>% select(Country_Region),
# top_Increase_Deaths_Avg_Avg%>% select(Country_Region),
# top_Deaths %>% select(Country_Region)) %>% unique() %>% pull(Country_Region)
CountryList <- unique(c(top_Increase_Weighted_Deaths_Avg_Avg$Country_Region,
top_Increase_Deaths_Avg_Avg$Country_Region,
top_Deaths$Country_Region,
"Portugal"))
#c("United Kingdom","France","Italy","Germany","Belgium","Spain","Greece","Sweden","Norway","Finland","Czech Republic","Peru", "United States", "Brazil")